USE [200Millas]
GO

/****** Object:  StoredProcedure [dbo].[usp_ConsultarProducto]    Script Date: 10/06/2012 02:22:37 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		<dparedes>
-- Create date: <2012/10/06>
-- Description:	<Consultar Producto>
-- =============================================
CREATE PROCEDURE [dbo].[usp_ConsultarProducto] 
@vcod_pro char(3)
AS
BEGIN
	SELECT * FROM [200Millas].dbo.TB_PRODUCTO WHERE COD_PRO = @vcod_pro;
END

GO


USE [200Millas]
GO

/****** Object:  StoredProcedure [dbo].[usp_ListarProductos]    Script Date: 10/06/2012 02:22:37 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		<dparedes>
-- Create date: <2012/10/06>
-- Description:	<Listar Productos>
-- =============================================
CREATE PROCEDURE [dbo].[usp_ListarProductos] 
AS
BEGIN
	SELECT * FROM [200Millas].dbo.TB_PRODUCTO;
END

GO



